OPTIMIZER STATISTICS GATHERING
Short Description
Optimizer Statistics are being gathered for this object.
Detailed Description​
The object is being analyzed to update its statistics. This may be the result of a manual action, a scheduled task or result of a CREATE TABLE AS SELECT (CTAS).
Further Reading​
- Oracle Docs - How the Database Gathers Optimizer Statistics
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.